Oracle PL/SQL: LEFT JOIN example and syntax - The LEFT ... 2009年3月7日 - LEFT JOIN example and syntax - The LEFT JOIN (also called LEFT OUTER JOIN) keyword returns all rows from the left table (table_name.